NC Matched Statement Trx 11003k (NCABR011)

Easily find this page again using the shortlink: https://gpt.azrcrv.co.uk/NCABR011

Display Name: NC Matched Statement Trx 11003k
Physical Name: NCABR011
Technical Name: NC_Statement_Match_11003k

Seq No	Physical Name	Display Name	Dexterity Data Type	SQL Data Type	Length
1	BANKID	Bank ID	STR15_Bank_ID	String	15
2	NC_Statement_Number	NC_Statement_Number	Long Int	Long Integer	8
3	NC_Statement_Date	NC_Statement_Date	DATE	Date	6
4	NC_Trx_Date	NC_Trx_Date	DATE	Date	6
5	NC_Reference	NC_Reference	STR30	String	30
6	NC_Trx_Type	NC_Trx_Type	STR9	String	9
7	NC_Debit_Amount	NC_Debit_Amount	NC_Amount	Currency	15
8	NC_Credit_Amount	NC_Credit_Amount	NC_Amount	Currency	15
9	NC_Trx_Balance	NC_Trx_Balance	NC_Balance	Currency	15
10	NC_BL_Amount	NC_BL_Amount	NC_BL_Amount	Currency	15
11	NCCHQNUM	NC_Cheque_Number	STR20_Document_Number	String	20
12	NC_Cheque_Number	NC_Cheque_Number_OLD	STR6	String	6
13	NC_Match_Number	NC_Match_Number	NC_Match_Number	Long Integer	10
14	NC_Marked	NC_Marked	NC_Marked	Boolean	0
15	NC_Matched	NC_Matched	Boolean	Boolean	0
16	NC_Original_Trx_Type	NC_Original_Trx_Type	STR10	String	10
17	LNITMSEQ	Line Item Sequence	LI_Sequence_Number	Long Integer	10
18	CURRNIDX	Currency Index	INT3	Integer	3
	Key to the Currency Setup (MC40200). Click to show/hide SELECT ['NC Matched Statement Trx 11003k'].CURRNIDX AS 'NC Matched Statement Trx 11003k-Currency Index' ,['Currency Setup'].CURRNIDX AS 'Currency Setup-Currency Index' FROM NCABR011 AS ['NC Matched Statement Trx 11003k'] INNER JOIN DYNAMICS..MC40200 AS ['Currency Setup'] ON ['NC Matched Statement Trx 11003k'].CURRNIDX = ['Currency Setup'].CURRNIDX
19	NC_Bank_Amount	NC Bank Amount	DLR19_$S2	Currency	19
20	NC_Text_Reference	NC_Text_Reference	STR255	String	255